import 'package:flutter/material.dart';

void main() {
  runApp(MyApp());
}

class MyApp extends StatelessWidget {
  // This widget is the root of your application.
  @override
  Widget build(BuildContext context) {
    return MaterialApp(
      title: 'MyBatis 问号替换工具',
      theme: ThemeData(
        // This is the theme of your application.
        //
        // Try running your application with "flutter run". You'll see the
        // application has a blue toolbar. Then, without quitting the app, try
        // changing the primarySwatch below to Colors.green and then invoke
        // "hot reload" (press "r" in the console where you ran "flutter run",
        // or simply save your changes to "hot reload" in a Flutter IDE).
        // Notice that the counter didn't reset back to zero; the application
        // is not restarted.
        primarySwatch: Colors.blue,
      ),
      home: MyHomePage(title: 'MyBatis 问号替换工具'),
    );
  }
}

class MyHomePage extends StatefulWidget {
  MyHomePage({Key? key, required this.title}) : super(key: key);

  // This widget is the home page of your application. It is stateful, meaning
  // that it has a State object (defined below) that contains fields that affect
  // how it looks.

  // This class is the configuration for the state. It holds the values (in this
  // case the title) provided by the parent (in this case the App widget) and
  // used by the build method of the State. Fields in a Widget subclass are
  // always marked "final".

  final String title;

  @override
  _MyHomePageState createState() => _MyHomePageState();
}

class _MyHomePageState extends State<MyHomePage> {
  String msg = "";
  String sql = "";
  String param = "";
  String result = "";
  TextEditingController _sqlController = TextEditingController(text: "");
  TextEditingController _resultController = TextEditingController(text: "");
  TextEditingController _paramController = TextEditingController(text: "");

  @override
  void initState() {
    super.initState();
  }

  @override
  void dispose() {
    _resultController.dispose();
    _sqlController.dispose();
    _paramController.dispose();
    super.dispose();
  }

  void _convert() {
    setState(() {
      // This call to setState tells the Flutter framework that something has
      // changed in this State, which causes it to rerun the build method below
      // so that the display can reflect the updated values. If we changed
      // _counter without calling setState(), then the build method would not be
      // called again, and so nothing would appear to happen.
      this.sql = _sqlController.text;
      var split = sql.split("\n");
      // setState(() {
      this.msg = '';
      // });
      if (split.length < 2) {
        // setState(() {
        this.msg = '输入格式不对';
        // });
        return;
      }
      var replaceAll = split[0].replaceAll("Preparing: ", "");
      var _param = split[1].split("Parameters: ")[1];
      var split2 = _param.split(",");
      split2.forEach((element) {
        var valType = element.split("(");
        var val = valType[0];
        var isStr = valType[1].startsWith("String");
        if (isStr) {
          replaceAll = replaceAll.replaceFirst("?", "'" + val + "'");
        } else {
          replaceAll = replaceAll.replaceFirst("?", val);
        }
      });

      //   Preparing: with t as ( select id, warn_type_code, data_batch_time, max_grade from warn_event where (warn_type_code, data_batch_time) in ( select warn_type_code, max(data_batch_time) from warn_event t1 where t1.product_id = ? and t1.warn_type_code = ? group by warn_type_code ) ) select substr(t1.time,0,9) as "day", max(t1.max_grade) as "warnGrade" from t join warn_event_info t1 on t1.event_id = t.id join warn_weather_pre t2 on t2.warn_info_id = t1.id where t2.province_code = ? and t2.start_time >= ? and t2.end_time <= ? group by substr(t1.time,0,9)
      // 19:04:20.476 [main] DEBUG com.powergrid.mapper.warning.WarnWeatherPointMapper.stats3dayWarnGradeGdfsWarning - ==> Parameters: gdfs_warning(String), warning_short_term_pre(String), 320000(String), 202106150000(String), 202106150000(String)
      // setState(() {
      this._paramController.text = _param;
      // this.result = replaceAll;
      this._resultController.text = replaceAll;
      // });
    });
  }

  @override
  Widget build(BuildContext context) {
    // This method is rerun every time setState is called, for instance as done
    // by the _incrementCounter method above.
    //
    // The Flutter framework has been optimized to make rerunning build methods
    // fast, so that you can just rebuild anything that needs updating rather
    // than having to individually change instances of widgets.
    return Scaffold(
      extendBody: true,
      appBar: AppBar(
        // Here we take the value from the MyHomePage object that was created by
        // the App.build method, and use it to set our appbar title.
        title: Text(widget.title),
      ),

      body: Padding(
        padding: EdgeInsets.all(8),
        child: Center(
          // Center is a layout widget. It takes a single child and positions it
          // in the middle of the parent.
          child: Column(
            // Column is also a layout widget. It takes a list of children and
            // arranges them vertically. By default, it sizes itself to fit its
            // children horizontally, and tries to be as tall as its parent.
            //
            // Invoke "debug painting" (press "p" in the console, choose the
            // "Toggle Debug Paint" action from the Flutter Inspector in Android
            // Studio, or the "Toggle Debug Paint" command in Visual Studio Code)
            // to see the wireframe for each widget.
            //
            // Column has various properties to control how it sizes itself and
            // how it positions its children. Here we use mainAxisAlignment to
            // center the children vertically; the main axis here is the vertical
            // axis because Columns are vertical (the cross axis would be
            // horizontal).
            mainAxisAlignment: MainAxisAlignment.spaceAround,

            children: <Widget>[
              Expanded(
                  child: TextField(
                controller: _sqlController,
                keyboardType: TextInputType.multiline,
                onSubmitted: (String value) async {
                  _sqlController.text = value;
                },
                maxLines: null,
                minLines: 10,
                decoration: InputDecoration(
                    border: OutlineInputBorder(),
                    hintText: 'sql',
                    labelText: "原始SQL"),
              )),
              SizedBox(height: 16),
              Row(
                mainAxisAlignment: MainAxisAlignment.center,
                children: [
                  ButtonBar(
                    children: [
                      SizedBox(height: 16),
                      ElevatedButton(
                        style: ButtonStyle(
                          textStyle: MaterialStateProperty.all(
                              TextStyle(fontSize: 32)), //字体
                        ),
                        onPressed: () async {
                          _sqlController.clear();
                          _paramController.clear();
                          _resultController.clear();
                        },
                        child: Icon(Icons.delete_outline),
                      )
                    ],
                  )
                ],
              ),
              SizedBox(height: 16),
              TextField(
                controller: _paramController,
                maxLines: 2,
                onSubmitted: (String value) async {
                  setState(() {
                    _paramController.text = value;
                  });
                },
                decoration: InputDecoration(
                    border: OutlineInputBorder(),
                    hintText: '$param',
                    labelText: "参数"),
              ),
              SizedBox(height: 16),
              TextField(
                controller: _resultController,
                keyboardType: TextInputType.multiline,
                minLines: 8,
                maxLines: null,
                onSubmitted: (String value) async {
                  setState(() {
                    this._resultController.text = value;
                  });
                },
                decoration: InputDecoration(
                    border: OutlineInputBorder(),
                    hintText: '转换后的结果',
                    labelText: "结果"),
              )
            ],
          ),
        ),
      ),
      // persistentFooterButtons: [
      //   IconButton(onPressed: null, icon: Icon( Icons.leak_add_outlined))
      // ],
      floatingActionButtonLocation: FloatingActionButtonLocation.endFloat,
      floatingActionButton: FloatingActionButton(
        onPressed: _convert,
        tooltip: '转换',
        child: Icon(Icons.wifi_protected_setup),
      ), // This trailing comma makes auto-formatting nicer for build methods.
    );
  }
}
